Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
WorkstationID (FK)(PK) | The unique identifier for the Workstation that is defining this ReportingPeriod. | ID_WS | Identity | integer | Workstation(AS_WS) |
ReportingPeriodID (FK)(PK) | The unique system assigned identifier for a particular ReportingPeriod. | ID_PRD_RP | Identity | integer | ReportingPeriod(CA_PRD_RP) |
StartTransactionID (FK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN_SRT | IdentityUUID | char(32) | WorkstationPeriodStartTransaction(TR_WS_PD_SRT) |
EndTransactionID (FK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN_END | IdentityUUID | char(32) | WorkstationPeriodEndTransaction(TR_WS_PRD_END) |